Summary Information

Introduction

  • The purpose of this project is to evaluate how Airbnb listing information compares within NYC. Since Airbnb is gaining marketshare in the tourist accommodation market, which has been dominated by hotels, hostels, and motels in the past, and pricing have changed overtime, our group believes it is important to find the impact Airbnb will have on the future.

  • Dataset Source: Kaggle

Summary Information

The NYC dataset has over 48895 observations recording over 16 features for each house that hosted Airbnb guests in 2019. Among the features are room type, price, host name, and so on. According to the dataset, 22326 private rooms, 25409 Entire homes/apts, and 1160 shared rooms were hosted in 2019. The most expensive of them being 10000 and the least expensive being 0. Note that some airbnb housese can claim to have zero dollars in price per night because they don’t charge per night, rather by week or month. The most popular neighbourhood is Williamsburg, while the most popular neighbourhood group is Manhattan. Lastly, the sum of all reviews posted to Airbnb in 2019 is 1138005.

Summary Table

This table investigates and compares how the average Airbnb listing information such as price, number of minimum nights required, and room availability out of 365 days, compares between different NYC neighborhoods. In order to make this comparison, the listing was grouped by neighborhoods.

Neighborhood Area Average Price for a Room ($ USD) Average Minimum of Nights Required for a Room Average Room Availability out of 365 Days (Days)
Bronx 87.50 4.6 165.8
Brooklyn 124.38 6.1 100.2
Manhattan 196.88 8.6 112.0
Queens 99.52 5.2 144.5
Staten Island 114.81 4.8 199.7

Interpretations & Insights:

  • The highest average price for a room is in Manhattan for a whopping $196.88 while the lowest is in Bronx for $87.50.
  • The largest average minimum of nights required for a room is in Manhattan with 8.6 days while the lowest is in Bronx with 4.6 days.
  • The average room availability out of 365 days is the highest in Staten Island with 199.7 days while the lowest is in Brooklyn with 100.2 dats.

Charts

Bar Chart

Purpose: This chart was meant to visually inform the viewer of how the number of Airbnb listings vary per neighborhood. Using a bar chart can help allow the viewer to easily contrast the different number of listings between neighborhoods.

Insights:

  • The neighborhood group with the most number of Airbnb listings is Manhattan with about 22,500~ listings. Brooklyn comes in close for 2nd with about 20,000~ listings.
  • The neighborhood group with the least number of Airbnb listings is Staten Island with about 1,000~ listings.

Chart Map

Purpose: This chart was intended to show the distribution of Airbnb-hosted houses in New York City to expand the user’s perspective of which neighbourhoods seem to dominate the real estate market (in terms of temperoray renting).

Insights:

  • It appears that houses closer to a coast or near central NY appear to dominate the map. Perhaps because people are attracted to the view.

  • The popup labels reveal that house prices in densely populated Airbnb markets, on average, are much higher compared to regions with fewer Airbnb houses for guests.

Donut Pie Chart

Purpose: This chart is intended to show the portion of types of different rooms on Airbnb in New York City. A pie chart is very useful in this situation because it gives people a intuative way to understand the proportion of different room types.

Insights:

  • The number of entire home/apt listings is almost the same as the number of private room listings.
  • The proportion of shared rooms listings is very small. It might be a result of most people going to New York City wishing to live in a private space.